﻿<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>ReadMe</title>
</head>
<body>
<h2> ASP.NET SQL SERVER ADMIN </h2>
    <form id="form1" runat="server">
    <div>
    <p>
    
The purpose of this tool is to provide web based interface for stored procedure generation and meta data retrieval . You would have to set up the sql server logins and security. This tool works on Sql Server 2005 , it has been developed with Visual Studio 2008 but you should be able to run it in VS 2005 as well. It uses Asp.Net 3.5 , should work on Asp.net 2.0 as well - if not please report issues ... Note, that all the code generation is based on the tables' meta data , which is retrieved mainly by using the extended properties of the columns , so you d better start with the "Add extended props " button otherwise mot much would happen ...

    </p>
    <p> 
Note that this is <strong>STRONG BETA </strong> - some of the buttons do not work ... some results might not be fully tested ... so I would appreciate some feedbacks, optionions ( positive and negative as well ). At the end of this page is the TODO: section

    </p>
    <p> 
Note that the retrieval of meta data needed for the code generation is based on tables' extended properties - i.e. in order to generate stored procedures per table one has to start with the Add Extended Props button and run it against the sql server ...</p>
    <p>OK , now let's get some action ... go to  <a href="admin/login.aspx"> login page </a></p>
    
    
    
    <h3> Thanks to ... </h3>
    <ul>
     <li>Heikki Kauranen - my collegue from <a href="http://www.oxit.fi">OXIT</a>, who has developed most of the meta data related sql queries and thought me so much about application developing and SQL Server </li>
<li>Sameera Perera - for the best database wrapper for .Net I have seen ... Check his blog at <a href="http://www.codoxide.com/post/My-Favorite-Database-Wrapper-for-C.aspx" > his blog post about it</a></li>
    <li>Mehdi Keramati - for the best client based stored procedure generator  <a href="http://www.codeplex.com/spgen"></a></li>
    <li>All other guys I have copied code from at 3:00 AM without memorizing their names ... There might be some mentionings in the source .... </li>
   
   <li><a href="http://www.codeproject.com>CodeProject</a> - for the great environment for learning and discussing real coding .... </li>
   <!--  <li></li>
    <li></li>
    <li></li>
    -->
    </ul>
<h3>TODO</h3>    

    <ul>
    <li>Enable retrieval of minimalistic ds for meta generation without having to add extended properties to a table</li>
    <li></li>
   <!--  <li></li>
    <li></li>
    <li></li>
    <li></li>
    <li></li>
    -->
    </ul>
    
    </div>
    </form>
</body>
</html>
